--
-- PostgreSQL database dump
--

-- Dumped from database version 15.6
-- Dumped by pg_dump version 15.6

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: substring_index(character varying, character varying, integer); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.substring_index(character varying, character varying, integer) RETURNS character varying
    LANGUAGE plpgsql IMMUTABLE STRICT
    AS $_$
DECLARE
tokens varchar[];
length integer ;
indexnum integer;
BEGIN
tokens := pg_catalog.string_to_array($1, $2);
length := pg_catalog.array_upper(tokens, 1);
indexnum := length - ($3 * -1) + 1;
IF $3 >= 0 THEN
RETURN pg_catalog.array_to_string(tokens[1:$3], $2);
ELSE
RETURN pg_catalog.array_to_string(tokens[indexnum:length], $2);
END IF;
END;
$_$;


ALTER FUNCTION public.substring_index(character varying, character varying, integer) OWNER TO postgres;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: gen_table; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.gen_table (
    table_id integer NOT NULL,
    table_name character varying(200) DEFAULT ''::character varying,
    table_comment character varying(500) DEFAULT ''::character varying,
    sub_table_name character varying(64) DEFAULT NULL::character varying,
    sub_table_fk_name character varying(64) DEFAULT NULL::character varying,
    class_name character varying(100) DEFAULT ''::character varying,
    tpl_category character varying(200) DEFAULT 'crud'::character varying,
    tpl_web_type character varying(30) DEFAULT ''::character varying,
    package_name character varying(100),
    module_name character varying(30),
    business_name character varying(30),
    function_name character varying(50),
    function_author character varying(50),
    gen_type character(1) DEFAULT '0'::bpchar,
    gen_path character varying(200) DEFAULT '/'::character varying,
    options character varying(1000),
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500) DEFAULT NULL::character varying
);


ALTER TABLE public.gen_table OWNER TO postgres;

--
-- Name: gen_table_column; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.gen_table_column (
    column_id integer NOT NULL,
    table_id bigint,
    column_name character varying(200),
    column_comment character varying(500),
    column_type character varying(100),
    java_type character varying(500),
    java_field character varying(200),
    is_pk character(1),
    is_increment character(1),
    is_required character(1),
    is_insert character(1),
    is_edit character(1),
    is_list character(1),
    is_query character(1),
    query_type character varying(200) DEFAULT 'EQ'::character varying,
    html_type character varying(200),
    dict_type character varying(200) DEFAULT ''::character varying,
    sort integer,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone
);


ALTER TABLE public.gen_table_column OWNER TO postgres;

--
-- Name: gen_table_column_column_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.gen_table_column_column_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.gen_table_column_column_id_seq OWNER TO postgres;

--
-- Name: gen_table_column_column_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.gen_table_column_column_id_seq OWNED BY public.gen_table_column.column_id;


--
-- Name: gen_table_table_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.gen_table_table_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.gen_table_table_id_seq OWNER TO postgres;

--
-- Name: gen_table_table_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.gen_table_table_id_seq OWNED BY public.gen_table.table_id;


--
-- Name: list_column; Type: VIEW; Schema: public; Owner: postgres
--

CREATE VIEW public.list_column AS
 SELECT c.relname AS table_name,
    a.attname AS column_name,
    d.description AS column_comment,
        CASE
            WHEN (a.attnotnull AND (con.conname IS NULL)) THEN 1
            ELSE 0
        END AS is_required,
        CASE
            WHEN (con.conname IS NOT NULL) THEN 1
            ELSE 0
        END AS is_pk,
    a.attnum AS sort,
        CASE
            WHEN ("position"(pg_get_expr(ad.adbin, ad.adrelid), ((((c.relname)::text || '_'::text) || (a.attname)::text) || '_seq'::text)) > 0) THEN 1
            ELSE 0
        END AS is_increment,
    btrim(
        CASE
            WHEN ((t.typelem <> (0)::oid) AND (t.typlen = '-1'::integer)) THEN 'ARRAY'::text
            ELSE
            CASE
                WHEN (t.typtype = 'd'::"char") THEN format_type(t.typbasetype, NULL::integer)
                ELSE format_type(a.atttypid, NULL::integer)
            END
        END, '"'::text) AS column_type
   FROM (((((pg_attribute a
     JOIN (pg_class c
     JOIN pg_namespace n ON ((c.relnamespace = n.oid))) ON ((a.attrelid = c.oid)))
     LEFT JOIN pg_description d ON (((d.objoid = c.oid) AND (a.attnum = d.objsubid))))
     LEFT JOIN pg_constraint con ON (((con.conrelid = c.oid) AND (a.attnum = ANY (con.conkey)))))
     LEFT JOIN pg_attrdef ad ON (((a.attrelid = ad.adrelid) AND (a.attnum = ad.adnum))))
     LEFT JOIN pg_type t ON ((a.atttypid = t.oid)))
  WHERE ((c.relkind = ANY (ARRAY['r'::"char", 'p'::"char"])) AND (a.attnum > 0) AND (n.nspname = 'public'::name) AND (NOT a.attisdropped))
  ORDER BY c.relname, a.attnum;


ALTER TABLE public.list_column OWNER TO postgres;

--
-- Name: list_table; Type: VIEW; Schema: public; Owner: postgres
--

CREATE VIEW public.list_table AS
 SELECT c.relname AS table_name,
    obj_description(c.oid) AS table_comment,
    CURRENT_TIMESTAMP AS create_time,
    CURRENT_TIMESTAMP AS update_time
   FROM (pg_class c
     LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace)))
  WHERE ((c.relkind = ANY (ARRAY['r'::"char", 'p'::"char"])) AND (c.relname !~~ 'spatial_%'::text) AND (n.nspname = 'public'::name) AND (n.nspname <> ''::name));


ALTER TABLE public.list_table OWNER TO postgres;

--
-- Name: qrtz_blob_triggers; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.qrtz_blob_triggers (
    sched_name character varying(120) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    bytea_data bytea
);


ALTER TABLE public.qrtz_blob_triggers OWNER TO postgres;

--
-- Name: qrtz_calendars; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.qrtz_calendars (
    sched_name character varying(120) NOT NULL,
    calendar_name character varying(200) NOT NULL,
    calendar bytea NOT NULL
);


ALTER TABLE public.qrtz_calendars OWNER TO postgres;

--
-- Name: qrtz_cron_triggers; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.qrtz_cron_triggers (
    sched_name character varying(120) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    cron_expression character varying(200) NOT NULL,
    time_zone_id character varying(80)
);


ALTER TABLE public.qrtz_cron_triggers OWNER TO postgres;

--
-- Name: qrtz_fired_triggers; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.qrtz_fired_triggers (
    sched_name character varying(120) NOT NULL,
    entry_id character varying(95) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    instance_name character varying(200) NOT NULL,
    fired_time bigint NOT NULL,
    sched_time bigint NOT NULL,
    priority integer NOT NULL,
    state character varying(16) NOT NULL,
    job_name character varying(200),
    job_group character varying(200),
    is_nonconcurrent character varying(1),
    requests_recovery character varying(1)
);


ALTER TABLE public.qrtz_fired_triggers OWNER TO postgres;

--
-- Name: qrtz_job_details; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.qrtz_job_details (
    sched_name character varying(120) NOT NULL,
    job_name character varying(200) NOT NULL,
    job_group character varying(200) NOT NULL,
    description character varying(250),
    job_class_name character varying(250) NOT NULL,
    is_durable character varying(1) NOT NULL,
    is_nonconcurrent character varying(1) NOT NULL,
    is_update_data character varying(1) NOT NULL,
    requests_recovery character varying(1) NOT NULL,
    job_data bytea
);


ALTER TABLE public.qrtz_job_details OWNER TO postgres;

--
-- Name: qrtz_locks; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.qrtz_locks (
    sched_name character varying(120) NOT NULL,
    lock_name character varying(40) NOT NULL
);


ALTER TABLE public.qrtz_locks OWNER TO postgres;

--
-- Name: qrtz_paused_trigger_grps; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.qrtz_paused_trigger_grps (
    sched_name character varying(120) NOT NULL,
    trigger_group character varying(200) NOT NULL
);


ALTER TABLE public.qrtz_paused_trigger_grps OWNER TO postgres;

--
-- Name: qrtz_scheduler_state; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.qrtz_scheduler_state (
    sched_name character varying(120) NOT NULL,
    instance_name character varying(200) NOT NULL,
    last_checkin_time bigint NOT NULL,
    checkin_interval bigint NOT NULL
);


ALTER TABLE public.qrtz_scheduler_state OWNER TO postgres;

--
-- Name: qrtz_simple_triggers; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.qrtz_simple_triggers (
    sched_name character varying(120) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    repeat_count bigint NOT NULL,
    repeat_interval bigint NOT NULL,
    times_triggered bigint NOT NULL
);


ALTER TABLE public.qrtz_simple_triggers OWNER TO postgres;

--
-- Name: qrtz_simprop_triggers; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.qrtz_simprop_triggers (
    sched_name character varying(120) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    str_prop_1 character varying(512),
    str_prop_2 character varying(512),
    str_prop_3 character varying(512),
    int_prop_1 integer,
    int_prop_2 integer,
    long_prop_1 bigint,
    long_prop_2 bigint,
    dec_prop_1 numeric(13,4),
    dec_prop_2 numeric(13,4),
    bool_prop_1 character varying(1),
    bool_prop_2 character varying(1)
);


ALTER TABLE public.qrtz_simprop_triggers OWNER TO postgres;

--
-- Name: qrtz_triggers; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.qrtz_triggers (
    sched_name character varying(120) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    job_name character varying(200) NOT NULL,
    job_group character varying(200) NOT NULL,
    description character varying(250),
    next_fire_time bigint,
    prev_fire_time bigint,
    priority integer,
    trigger_state character varying(16) NOT NULL,
    trigger_type character varying(8) NOT NULL,
    start_time bigint NOT NULL,
    end_time bigint,
    calendar_name character varying(200),
    misfire_instr smallint,
    job_data bytea
);


ALTER TABLE public.qrtz_triggers OWNER TO postgres;

--
-- Name: sys_config; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_config (
    config_id integer NOT NULL,
    config_name character varying(100) DEFAULT ''::character varying,
    config_key character varying(100) DEFAULT ''::character varying,
    config_value character varying(500) DEFAULT ''::character varying,
    config_type character(1) DEFAULT 'N'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500) DEFAULT NULL::character varying
);


ALTER TABLE public.sys_config OWNER TO postgres;

--
-- Name: sys_config_config_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_config_config_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_config_config_id_seq OWNER TO postgres;

--
-- Name: sys_config_config_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_config_config_id_seq OWNED BY public.sys_config.config_id;


--
-- Name: sys_dept; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_dept (
    dept_id integer NOT NULL,
    parent_id bigint DEFAULT 0,
    ancestors character varying(50) DEFAULT ''::character varying,
    dept_name character varying(30) DEFAULT ''::character varying,
    order_num integer DEFAULT 0,
    leader character varying(20) DEFAULT NULL::character varying,
    phone character varying(11) DEFAULT NULL::character varying,
    email character varying(50) DEFAULT NULL::character varying,
    status character(1) DEFAULT '0'::bpchar,
    del_flag character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone
);


ALTER TABLE public.sys_dept OWNER TO postgres;

--
-- Name: sys_dept_dept_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_dept_dept_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_dept_dept_id_seq OWNER TO postgres;

--
-- Name: sys_dept_dept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_dept_dept_id_seq OWNED BY public.sys_dept.dept_id;


--
-- Name: sys_dict_data; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_dict_data (
    dict_code integer NOT NULL,
    dict_sort integer DEFAULT 0,
    dict_label character varying(100) DEFAULT ''::character varying,
    dict_value character varying(100) DEFAULT ''::character varying,
    dict_type character varying(100) DEFAULT ''::character varying,
    css_class character varying(100) DEFAULT NULL::character varying,
    list_class character varying(100) DEFAULT NULL::character varying,
    is_default character(1) DEFAULT 'N'::bpchar,
    status character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500) DEFAULT NULL::character varying
);


ALTER TABLE public.sys_dict_data OWNER TO postgres;

--
-- Name: sys_dict_data_dict_code_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_dict_data_dict_code_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_dict_data_dict_code_seq OWNER TO postgres;

--
-- Name: sys_dict_data_dict_code_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_dict_data_dict_code_seq OWNED BY public.sys_dict_data.dict_code;


--
-- Name: sys_dict_type; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_dict_type (
    dict_id integer NOT NULL,
    dict_name character varying(100) DEFAULT ''::character varying,
    dict_type character varying(100) DEFAULT ''::character varying,
    status character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500) DEFAULT NULL::character varying
);


ALTER TABLE public.sys_dict_type OWNER TO postgres;

--
-- Name: sys_dict_type_dict_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_dict_type_dict_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_dict_type_dict_id_seq OWNER TO postgres;

--
-- Name: sys_dict_type_dict_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_dict_type_dict_id_seq OWNED BY public.sys_dict_type.dict_id;


--
-- Name: sys_job; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_job (
    job_id integer NOT NULL,
    job_name character varying(64) DEFAULT ''::character varying NOT NULL,
    job_group character varying(64) DEFAULT 'DEFAULT'::character varying NOT NULL,
    invoke_target character varying(500) NOT NULL,
    cron_expression character varying(255) DEFAULT ''::character varying,
    misfire_policy character varying(20) DEFAULT '3'::character varying,
    concurrent character(1) DEFAULT '1'::bpchar,
    status character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500) DEFAULT ''::character varying
);


ALTER TABLE public.sys_job OWNER TO postgres;

--
-- Name: sys_job_job_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_job_job_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_job_job_id_seq OWNER TO postgres;

--
-- Name: sys_job_job_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_job_job_id_seq OWNED BY public.sys_job.job_id;


--
-- Name: sys_job_log; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_job_log (
    job_log_id integer NOT NULL,
    job_name character varying(64) NOT NULL,
    job_group character varying(64) NOT NULL,
    invoke_target character varying(500) NOT NULL,
    job_message character varying(500),
    status character(1) DEFAULT '0'::bpchar,
    exception_info character varying(2000) DEFAULT ''::character varying,
    create_time timestamp without time zone
);


ALTER TABLE public.sys_job_log OWNER TO postgres;

--
-- Name: sys_job_log_job_log_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_job_log_job_log_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_job_log_job_log_id_seq OWNER TO postgres;

--
-- Name: sys_job_log_job_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_job_log_job_log_id_seq OWNED BY public.sys_job_log.job_log_id;


--
-- Name: sys_logininfor; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_logininfor (
    info_id integer NOT NULL,
    user_name character varying(50) DEFAULT ''::character varying,
    ipaddr character varying(128) DEFAULT ''::character varying,
    status character(1) DEFAULT '0'::bpchar,
    msg character varying(255) DEFAULT ''::character varying,
    access_time timestamp without time zone
);


ALTER TABLE public.sys_logininfor OWNER TO postgres;

--
-- Name: sys_logininfor_info_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_logininfor_info_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_logininfor_info_id_seq OWNER TO postgres;

--
-- Name: sys_logininfor_info_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_logininfor_info_id_seq OWNED BY public.sys_logininfor.info_id;


--
-- Name: sys_menu; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_menu (
    menu_id integer NOT NULL,
    menu_name character varying(50) NOT NULL,
    parent_id bigint DEFAULT 0,
    order_num integer DEFAULT 0,
    path character varying(200) DEFAULT ''::character varying,
    component character varying(255) DEFAULT NULL::character varying,
    query character varying(255) DEFAULT NULL::character varying,
    menu_type character(1) DEFAULT ''::bpchar,
    visible character(1) DEFAULT 0,
    status character(1) DEFAULT 0,
    perms character varying(100) DEFAULT NULL::character varying,
    icon character varying(100) DEFAULT '#'::character varying,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500) DEFAULT ''::character varying,
    route_name character varying(52) DEFAULT ''::character varying,
    is_frame character varying(5) DEFAULT '1'::character varying,
    is_cache character varying(5) DEFAULT '0'::character varying
);


ALTER TABLE public.sys_menu OWNER TO postgres;

--
-- Name: sys_menu_menu_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_menu_menu_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_menu_menu_id_seq OWNER TO postgres;

--
-- Name: sys_menu_menu_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_menu_menu_id_seq OWNED BY public.sys_menu.menu_id;


--
-- Name: sys_notice; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_notice (
    notice_id integer NOT NULL,
    notice_title character varying(50) NOT NULL,
    notice_type character(1) NOT NULL,
    notice_content text,
    status character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(255) DEFAULT NULL::character varying
);


ALTER TABLE public.sys_notice OWNER TO postgres;

--
-- Name: sys_notice_notice_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_notice_notice_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_notice_notice_id_seq OWNER TO postgres;

--
-- Name: sys_notice_notice_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_notice_notice_id_seq OWNED BY public.sys_notice.notice_id;


--
-- Name: sys_oper_log; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_oper_log (
    oper_id integer NOT NULL,
    title character varying(50) DEFAULT ''::character varying,
    business_type integer DEFAULT 0,
    method character varying(100) DEFAULT ''::character varying,
    request_method character varying(10) DEFAULT ''::character varying,
    operator_type integer DEFAULT 0,
    oper_name character varying(50) DEFAULT ''::character varying,
    dept_name character varying(50) DEFAULT ''::character varying,
    oper_url character varying(255) DEFAULT ''::character varying,
    oper_ip character varying(128) DEFAULT ''::character varying,
    oper_location character varying(255) DEFAULT ''::character varying,
    oper_param character varying(2000) DEFAULT ''::character varying,
    json_result character varying(2000) DEFAULT ''::character varying,
    status integer DEFAULT 0,
    error_msg character varying(2000) DEFAULT ''::character varying,
    oper_time timestamp without time zone,
    cost_time bigint DEFAULT 0
);


ALTER TABLE public.sys_oper_log OWNER TO postgres;

--
-- Name: sys_oper_log_oper_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_oper_log_oper_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_oper_log_oper_id_seq OWNER TO postgres;

--
-- Name: sys_oper_log_oper_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_oper_log_oper_id_seq OWNED BY public.sys_oper_log.oper_id;


--
-- Name: sys_post; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_post (
    post_id integer NOT NULL,
    post_code character varying(64) NOT NULL,
    post_name character varying(50) NOT NULL,
    post_sort integer NOT NULL,
    status character(1) NOT NULL,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500) DEFAULT NULL::character varying
);


ALTER TABLE public.sys_post OWNER TO postgres;

--
-- Name: sys_post_post_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_post_post_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_post_post_id_seq OWNER TO postgres;

--
-- Name: sys_post_post_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_post_post_id_seq OWNED BY public.sys_post.post_id;


--
-- Name: sys_role; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_role (
    role_id integer NOT NULL,
    role_name character varying(30) NOT NULL,
    role_key character varying(100) NOT NULL,
    role_sort integer NOT NULL,
    data_scope character(1) DEFAULT '1'::bpchar,
    status character(1) NOT NULL,
    del_flag character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64),
    update_time timestamp without time zone,
    remark character varying(500),
    menu_check_strictly boolean DEFAULT (1)::boolean,
    dept_check_strictly boolean DEFAULT (1)::boolean
);


ALTER TABLE public.sys_role OWNER TO postgres;

--
-- Name: sys_role_dept; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_role_dept (
    role_id bigint NOT NULL,
    dept_id bigint NOT NULL
);


ALTER TABLE public.sys_role_dept OWNER TO postgres;

--
-- Name: sys_role_menu; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_role_menu (
    role_id bigint NOT NULL,
    menu_id bigint NOT NULL
);


ALTER TABLE public.sys_role_menu OWNER TO postgres;

--
-- Name: sys_role_role_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_role_role_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_role_role_id_seq OWNER TO postgres;

--
-- Name: sys_role_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_role_role_id_seq OWNED BY public.sys_role.role_id;


--
-- Name: sys_user; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_user (
    user_id integer NOT NULL,
    dept_id bigint,
    user_name character varying(30) NOT NULL,
    nick_name character varying(30) NOT NULL,
    user_type character varying(2) DEFAULT '00'::character varying,
    email character varying(50) DEFAULT ''::character varying,
    phonenumber character varying(11) DEFAULT ''::character varying,
    sex character(1) DEFAULT '0'::bpchar,
    avatar character varying(100) DEFAULT ''::character varying,
    password character varying(100) DEFAULT ''::character varying,
    status character(1) DEFAULT '0'::bpchar,
    del_flag character(1) DEFAULT '0'::bpchar,
    login_ip character varying(128) DEFAULT ''::character varying,
    login_date timestamp without time zone,
    create_by character varying(64),
    create_time timestamp without time zone,
    update_by character varying(64),
    update_time timestamp without time zone,
    remark character varying(500)
);


ALTER TABLE public.sys_user OWNER TO postgres;

--
-- Name: COLUMN sys_user.user_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_user.user_name IS '用户名';


--
-- Name: sys_user_post; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_user_post (
    user_id bigint NOT NULL,
    post_id bigint NOT NULL
);


ALTER TABLE public.sys_user_post OWNER TO postgres;

--
-- Name: sys_user_role; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_user_role (
    user_id bigint NOT NULL,
    role_id bigint NOT NULL
);


ALTER TABLE public.sys_user_role OWNER TO postgres;

--
-- Name: sys_user_user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_user_user_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_user_user_id_seq OWNER TO postgres;

--
-- Name: sys_user_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_user_user_id_seq OWNED BY public.sys_user.user_id;


--
-- Name: gen_table table_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.gen_table ALTER COLUMN table_id SET DEFAULT nextval('public.gen_table_table_id_seq'::regclass);


--
-- Name: gen_table_column column_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.gen_table_column ALTER COLUMN column_id SET DEFAULT nextval('public.gen_table_column_column_id_seq'::regclass);


--
-- Name: sys_config config_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_config ALTER COLUMN config_id SET DEFAULT nextval('public.sys_config_config_id_seq'::regclass);


--
-- Name: sys_dept dept_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_dept ALTER COLUMN dept_id SET DEFAULT nextval('public.sys_dept_dept_id_seq'::regclass);


--
-- Name: sys_dict_data dict_code; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_dict_data ALTER COLUMN dict_code SET DEFAULT nextval('public.sys_dict_data_dict_code_seq'::regclass);


--
-- Name: sys_dict_type dict_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_dict_type ALTER COLUMN dict_id SET DEFAULT nextval('public.sys_dict_type_dict_id_seq'::regclass);


--
-- Name: sys_job job_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_job ALTER COLUMN job_id SET DEFAULT nextval('public.sys_job_job_id_seq'::regclass);


--
-- Name: sys_job_log job_log_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_job_log ALTER COLUMN job_log_id SET DEFAULT nextval('public.sys_job_log_job_log_id_seq'::regclass);


--
-- Name: sys_logininfor info_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_logininfor ALTER COLUMN info_id SET DEFAULT nextval('public.sys_logininfor_info_id_seq'::regclass);


--
-- Name: sys_menu menu_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_menu ALTER COLUMN menu_id SET DEFAULT nextval('public.sys_menu_menu_id_seq'::regclass);


--
-- Name: sys_notice notice_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_notice ALTER COLUMN notice_id SET DEFAULT nextval('public.sys_notice_notice_id_seq'::regclass);


--
-- Name: sys_oper_log oper_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_oper_log ALTER COLUMN oper_id SET DEFAULT nextval('public.sys_oper_log_oper_id_seq'::regclass);


--
-- Name: sys_post post_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_post ALTER COLUMN post_id SET DEFAULT nextval('public.sys_post_post_id_seq'::regclass);


--
-- Name: sys_role role_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_role ALTER COLUMN role_id SET DEFAULT nextval('public.sys_role_role_id_seq'::regclass);


--
-- Name: sys_user user_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_user ALTER COLUMN user_id SET DEFAULT nextval('public.sys_user_user_id_seq'::regclass);


--
-- Data for Name: gen_table; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, tpl_web_type, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) FROM stdin;
\.


--
-- Data for Name: gen_table_column; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.gen_table_column (column_id, table_id, column_name, column_comment, column_type, java_type, java_field, is_pk, is_increment, is_required, is_insert, is_edit, is_list, is_query, query_type, html_type, dict_type, sort, create_by, create_time, update_by, update_time) FROM stdin;
\.


--
-- Data for Name: qrtz_blob_triggers; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.qrtz_blob_triggers (sched_name, trigger_name, trigger_group, bytea_data) FROM stdin;
\.


--
-- Data for Name: qrtz_calendars; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.qrtz_calendars (sched_name, calendar_name, calendar) FROM stdin;
\.


--
-- Data for Name: qrtz_cron_triggers; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.qrtz_cron_triggers (sched_name, trigger_name, trigger_group, cron_expression, time_zone_id) FROM stdin;
\.


--
-- Data for Name: qrtz_fired_triggers; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.qrtz_fired_triggers (sched_name, entry_id, trigger_name, trigger_group, instance_name, fired_time, sched_time, priority, state, job_name, job_group, is_nonconcurrent, requests_recovery) FROM stdin;
\.


--
-- Data for Name: qrtz_job_details; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.qrtz_job_details (sched_name, job_name, job_group, description, job_class_name, is_durable, is_nonconcurrent, is_update_data, requests_recovery, job_data) FROM stdin;
\.


--
-- Data for Name: qrtz_locks; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.qrtz_locks (sched_name, lock_name) FROM stdin;
\.


--
-- Data for Name: qrtz_paused_trigger_grps; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.qrtz_paused_trigger_grps (sched_name, trigger_group) FROM stdin;
\.


--
-- Data for Name: qrtz_scheduler_state; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.qrtz_scheduler_state (sched_name, instance_name, last_checkin_time, checkin_interval) FROM stdin;
\.


--
-- Data for Name: qrtz_simple_triggers; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.qrtz_simple_triggers (sched_name, trigger_name, trigger_group, repeat_count, repeat_interval, times_triggered) FROM stdin;
\.


--
-- Data for Name: qrtz_simprop_triggers; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.qrtz_simprop_triggers (sched_name, trigger_name, trigger_group, str_prop_1, str_prop_2, str_prop_3, int_prop_1, int_prop_2, long_prop_1, long_prop_2, dec_prop_1, dec_prop_2, bool_prop_1, bool_prop_2) FROM stdin;
\.


--
-- Data for Name: qrtz_triggers; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.qrtz_triggers (sched_name, trigger_name, trigger_group, job_name, job_group, description, next_fire_time, prev_fire_time, priority, trigger_state, trigger_type, start_time, end_time, calendar_name, misfire_instr, job_data) FROM stdin;
\.


--
-- Data for Name: sys_config; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_config (config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	主框架页-默认皮肤样式名称	sys.index.skinName	skin-blue	Y	admin	2024-12-27 23:26:13.105216		\N	蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow
2	用户管理-账号初始密码	sys.user.initPassword	123456	Y	admin	2024-12-27 23:26:13.105216		\N	初始化密码 123456
3	主框架页-侧边栏主题	sys.index.sideTheme	theme-dark	Y	admin	2024-12-27 23:26:13.105216		\N	深色主题theme-dark，浅色主题theme-light
4	账号自助-是否开启用户注册功能	sys.account.registerUser	false	Y	admin	2024-12-27 23:26:13.105216		\N	是否开启注册用户功能（true开启，false关闭）
5	用户登录-黑名单列表	sys.login.blackIPList		Y	admin	2024-12-27 23:26:13.105216		\N	设置登录IP黑名单限制，多个匹配项以;分隔，支持匹配（*通配、网段）
\.


--
-- Data for Name: sys_dept; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_dept (dept_id, parent_id, ancestors, dept_name, order_num, leader, phone, email, status, del_flag, create_by, create_time, update_by, update_time) FROM stdin;
100	0	0	若依科技	0	若依	15888888888	ry@qq.com	0	0	admin	2024-12-27 23:08:33.252171		\N
101	100	0,100	深圳总公司	1	若依	15888888888	ry@qq.com	0	0	admin	2024-12-27 23:08:33.252171		\N
102	100	0,100	长沙分公司	2	若依	15888888888	ry@qq.com	0	0	admin	2024-12-27 23:08:33.252171		\N
103	101	0,100,101	研发部门	1	若依	15888888888	ry@qq.com	0	0	admin	2024-12-27 23:08:33.252171		\N
104	101	0,100,101	市场部门	2	若依	15888888888	ry@qq.com	0	0	admin	2024-12-27 23:08:33.252171		\N
105	101	0,100,101	测试部门	3	若依	15888888888	ry@qq.com	0	0	admin	2024-12-27 23:08:33.252171		\N
106	101	0,100,101	财务部门	4	若依	15888888888	ry@qq.com	0	0	admin	2024-12-27 23:08:33.252171		\N
107	101	0,100,101	运维部门	5	若依	15888888888	ry@qq.com	0	0	admin	2024-12-27 23:08:33.252171		\N
108	102	0,100,102	市场部门	1	若依	15888888888	ry@qq.com	0	0	admin	2024-12-27 23:08:33.252171		\N
109	102	0,100,102	财务部门	2	若依	15888888888	ry@qq.com	0	0	admin	2024-12-27 23:08:33.252171		\N
\.


--
-- Data for Name: sys_dict_data; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	1	男	0	sys_user_sex			Y	0	admin	2024-12-27 23:25:37.512038		\N	性别男
2	2	女	1	sys_user_sex			N	0	admin	2024-12-27 23:25:37.512038		\N	性别女
3	3	未知	2	sys_user_sex			N	0	admin	2024-12-27 23:25:37.512038		\N	性别未知
4	1	显示	0	sys_show_hide		primary	Y	0	admin	2024-12-27 23:25:37.512038		\N	显示菜单
5	2	隐藏	1	sys_show_hide		danger	N	0	admin	2024-12-27 23:25:37.512038		\N	隐藏菜单
6	1	正常	0	sys_normal_disable		primary	Y	0	admin	2024-12-27 23:25:37.512038		\N	正常状态
7	2	停用	1	sys_normal_disable		danger	N	0	admin	2024-12-27 23:25:37.512038		\N	停用状态
8	1	正常	0	sys_job_status		primary	Y	0	admin	2024-12-27 23:25:37.512038		\N	正常状态
9	2	暂停	1	sys_job_status		danger	N	0	admin	2024-12-27 23:25:37.512038		\N	停用状态
10	1	默认	DEFAULT	sys_job_group			Y	0	admin	2024-12-27 23:25:37.512038		\N	默认分组
11	2	系统	SYSTEM	sys_job_group			N	0	admin	2024-12-27 23:25:37.512038		\N	系统分组
12	1	是	Y	sys_yes_no		primary	Y	0	admin	2024-12-27 23:25:37.512038		\N	系统默认是
13	2	否	N	sys_yes_no		danger	N	0	admin	2024-12-27 23:25:37.512038		\N	系统默认否
14	1	通知	1	sys_notice_type		warning	Y	0	admin	2024-12-27 23:25:37.512038		\N	通知
15	2	公告	2	sys_notice_type		success	N	0	admin	2024-12-27 23:25:37.512038		\N	公告
16	1	正常	0	sys_notice_status		primary	Y	0	admin	2024-12-27 23:25:37.512038		\N	正常状态
17	2	关闭	1	sys_notice_status		danger	N	0	admin	2024-12-27 23:25:37.512038		\N	关闭状态
18	99	其他	0	sys_oper_type		info	N	0	admin	2024-12-27 23:25:37.512038		\N	其他操作
19	1	新增	1	sys_oper_type		info	N	0	admin	2024-12-27 23:25:37.512038		\N	新增操作
20	2	修改	2	sys_oper_type		info	N	0	admin	2024-12-27 23:25:37.512038		\N	修改操作
21	3	删除	3	sys_oper_type		danger	N	0	admin	2024-12-27 23:25:37.512038		\N	删除操作
22	4	授权	4	sys_oper_type		primary	N	0	admin	2024-12-27 23:25:37.512038		\N	授权操作
23	5	导出	5	sys_oper_type		warning	N	0	admin	2024-12-27 23:25:37.512038		\N	导出操作
24	6	导入	6	sys_oper_type		warning	N	0	admin	2024-12-27 23:25:37.512038		\N	导入操作
25	7	强退	7	sys_oper_type		danger	N	0	admin	2024-12-27 23:25:37.512038		\N	强退操作
26	8	生成代码	8	sys_oper_type		warning	N	0	admin	2024-12-27 23:25:37.512038		\N	生成操作
27	9	清空数据	9	sys_oper_type		danger	N	0	admin	2024-12-27 23:25:37.512038		\N	清空操作
28	1	成功	0	sys_common_status		primary	N	0	admin	2024-12-27 23:25:37.512038		\N	正常状态
29	2	失败	1	sys_common_status		danger	N	0	admin	2024-12-27 23:25:37.512038		\N	停用状态
\.


--
-- Data for Name: sys_dict_type; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	用户性别	sys_user_sex	0	admin	2024-12-27 23:24:49.543424		\N	用户性别列表
2	菜单状态	sys_show_hide	0	admin	2024-12-27 23:24:49.543424		\N	菜单状态列表
3	系统开关	sys_normal_disable	0	admin	2024-12-27 23:24:49.543424		\N	系统开关列表
4	任务状态	sys_job_status	0	admin	2024-12-27 23:24:49.543424		\N	任务状态列表
5	任务分组	sys_job_group	0	admin	2024-12-27 23:24:49.543424		\N	任务分组列表
6	系统是否	sys_yes_no	0	admin	2024-12-27 23:24:49.543424		\N	系统是否列表
7	通知类型	sys_notice_type	0	admin	2024-12-27 23:24:49.543424		\N	通知类型列表
8	通知状态	sys_notice_status	0	admin	2024-12-27 23:24:49.543424		\N	通知状态列表
9	操作类型	sys_oper_type	0	admin	2024-12-27 23:24:49.543424		\N	操作类型列表
10	系统状态	sys_common_status	0	admin	2024-12-27 23:24:49.543424		\N	登录状态列表
\.


--
-- Data for Name: sys_job; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_job (job_id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	系统默认（无参）	DEFAULT	ryTask.ryNoParams	0/10 * * * * ?	3	1	1	admin	2024-12-27 23:28:39.383353		\N	
\.


--
-- Data for Name: sys_job_log; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_job_log (job_log_id, job_name, job_group, invoke_target, job_message, status, exception_info, create_time) FROM stdin;
\.


--
-- Data for Name: sys_logininfor; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_logininfor (info_id, user_name, ipaddr, status, msg, access_time) FROM stdin;
1	admin	127.0.0.1	0	登录成功	2024-12-28 10:00:09.054737
2	admin	127.0.0.1	0	登录成功	2024-12-28 12:42:07.000471
3	admin	127.0.0.1	0	退出成功	2024-12-28 12:52:54.024906
4	ry	127.0.0.1	0	登录成功	2024-12-28 12:53:00.750052
5	ry	127.0.0.1	0	退出成功	2024-12-28 14:54:20.963749
6	admin	127.0.0.1	0	登录成功	2024-12-28 14:54:35.145529
7	admin	127.0.0.1	0	退出成功	2024-12-28 14:57:18.391186
8	admin	127.0.0.1	0	登录成功	2024-12-28 14:57:34.668512
9	admin	127.0.0.1	0	退出成功	2024-12-28 14:58:48.537214
10	admin	127.0.0.1	0	登录成功	2024-12-28 14:58:53.649742
11	admin	127.0.0.1	0	登录成功	2024-12-28 15:01:15.914414
\.


--
-- Data for Name: sys_menu; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_menu (menu_id, menu_name, parent_id, order_num, path, component, query, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, route_name, is_frame, is_cache) FROM stdin;
1	系统管理	0	1	system	\N		M	0	0		system	admin	2024-12-27 23:15:30.430232		\N	系统管理目录		1	0
4	若依官网	0	4	http://ruoyi.vip	\N		M	0	0		guide	admin	2024-12-27 23:15:30.430232		\N	若依官网地址		1	0
100	用户管理	1	1	user	system/user/index		C	0	0	system:user:list	user	admin	2024-12-27 23:15:30.430232		\N	用户管理菜单		1	0
101	角色管理	1	2	role	system/role/index		C	0	0	system:role:list	peoples	admin	2024-12-27 23:15:30.430232		\N	角色管理菜单		1	0
102	菜单管理	1	3	menu	system/menu/index		C	0	0	system:menu:list	tree-table	admin	2024-12-27 23:15:30.430232		\N	菜单管理菜单		1	0
103	部门管理	1	4	dept	system/dept/index		C	0	0	system:dept:list	tree	admin	2024-12-27 23:15:30.430232		\N	部门管理菜单		1	0
104	岗位管理	1	5	post	system/post/index		C	0	0	system:post:list	post	admin	2024-12-27 23:15:30.430232		\N	岗位管理菜单		1	0
105	字典管理	1	6	dict	system/dict/index		C	0	0	system:dict:list	dict	admin	2024-12-27 23:15:30.430232		\N	字典管理菜单		1	0
106	参数设置	1	7	config	system/config/index		C	0	0	system:config:list	edit	admin	2024-12-27 23:15:30.430232		\N	参数设置菜单		1	0
107	通知公告	1	8	notice	system/notice/index		C	0	0	system:notice:list	message	admin	2024-12-27 23:15:30.430232		\N	通知公告菜单		1	0
108	日志管理	1	9	log			M	0	0		log	admin	2024-12-27 23:15:30.430232		\N	日志管理菜单		1	0
109	在线用户	2	1	online	monitor/online/index		C	0	0	monitor:online:list	online	admin	2024-12-27 23:15:30.430232		\N	在线用户菜单		1	0
110	定时任务	2	2	job	monitor/job/index		C	0	0	monitor:job:list	job	admin	2024-12-27 23:15:30.430232		\N	定时任务菜单		1	0
111	Sentinel控制台	2	3	http://localhost:8718			C	0	0	monitor:sentinel:list	sentinel	admin	2024-12-27 23:15:30.430232		\N	流量控制菜单		1	0
112	Nacos控制台	2	4	http://localhost:8848/nacos			C	0	0	monitor:nacos:list	nacos	admin	2024-12-27 23:15:30.430232		\N	服务治理菜单		1	0
113	Admin控制台	2	5	http://localhost:9100/login			C	0	0	monitor:server:list	server	admin	2024-12-27 23:15:30.430232		\N	服务监控菜单		1	0
114	表单构建	3	1	build	tool/build/index		C	0	0	tool:build:list	build	admin	2024-12-27 23:15:30.430232		\N	表单构建菜单		1	0
116	系统接口	3	3	http://localhost:8080/swagger-ui/index.html			C	0	0	tool:swagger:list	swagger	admin	2024-12-27 23:15:30.430232		\N	系统接口菜单		1	0
500	操作日志	108	1	operlog	system/operlog/index		C	0	0	system:operlog:list	form	admin	2024-12-27 23:15:30.430232		\N	操作日志菜单		1	0
501	登录日志	108	2	logininfor	system/logininfor/index		C	0	0	system:logininfor:list	logininfor	admin	2024-12-27 23:15:30.430232		\N	登录日志菜单		1	0
1000	用户查询	100	1				F	0	0	system:user:query	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1001	用户新增	100	2				F	0	0	system:user:add	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1002	用户修改	100	3				F	0	0	system:user:edit	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1003	用户删除	100	4				F	0	0	system:user:remove	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1004	用户导出	100	5				F	0	0	system:user:export	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1005	用户导入	100	6				F	0	0	system:user:import	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1006	重置密码	100	7				F	0	0	system:user:resetPwd	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1007	角色查询	101	1				F	0	0	system:role:query	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1008	角色新增	101	2				F	0	0	system:role:add	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1009	角色修改	101	3				F	0	0	system:role:edit	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1010	角色删除	101	4				F	0	0	system:role:remove	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1011	角色导出	101	5				F	0	0	system:role:export	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1012	菜单查询	102	1				F	0	0	system:menu:query	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1013	菜单新增	102	2				F	0	0	system:menu:add	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1014	菜单修改	102	3				F	0	0	system:menu:edit	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1015	菜单删除	102	4				F	0	0	system:menu:remove	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1016	部门查询	103	1				F	0	0	system:dept:query	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1017	部门新增	103	2				F	0	0	system:dept:add	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1018	部门修改	103	3				F	0	0	system:dept:edit	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1019	部门删除	103	4				F	0	0	system:dept:remove	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1020	岗位查询	104	1				F	0	0	system:post:query	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1021	岗位新增	104	2				F	0	0	system:post:add	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1022	岗位修改	104	3				F	0	0	system:post:edit	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1023	岗位删除	104	4				F	0	0	system:post:remove	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1024	岗位导出	104	5				F	0	0	system:post:export	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1025	字典查询	105	1	#			F	0	0	system:dict:query	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1026	字典新增	105	2	#			F	0	0	system:dict:add	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1027	字典修改	105	3	#			F	0	0	system:dict:edit	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1028	字典删除	105	4	#			F	0	0	system:dict:remove	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1029	字典导出	105	5	#			F	0	0	system:dict:export	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1030	参数查询	106	1	#			F	0	0	system:config:query	#	admin	2024-12-27 23:15:30.430232		\N			1	0
2	系统监控	0	2	monitor	\N		M	0	0		monitor	admin	2024-12-27 23:15:30.430232	ry	2024-12-28 14:37:04.618978	系统监控目录		1	0
3	系统工具	0	3	tool	\N		M	0	0		tool	admin	2024-12-27 23:15:30.430232	ry	2024-12-28 14:37:07.763126	系统工具目录		1	0
1031	参数新增	106	2	#			F	0	0	system:config:add	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1032	参数修改	106	3	#			F	0	0	system:config:edit	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1033	参数删除	106	4	#			F	0	0	system:config:remove	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1034	参数导出	106	5	#			F	0	0	system:config:export	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1035	公告查询	107	1	#			F	0	0	system:notice:query	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1036	公告新增	107	2	#			F	0	0	system:notice:add	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1037	公告修改	107	3	#			F	0	0	system:notice:edit	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1038	公告删除	107	4	#			F	0	0	system:notice:remove	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1039	操作查询	500	1	#			F	0	0	system:operlog:query	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1040	操作删除	500	2	#			F	0	0	system:operlog:remove	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1041	日志导出	500	3	#			F	0	0	system:operlog:export	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1042	登录查询	501	1	#			F	0	0	system:logininfor:query	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1043	登录删除	501	2	#			F	0	0	system:logininfor:remove	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1044	日志导出	501	3	#			F	0	0	system:logininfor:export	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1045	账户解锁	501	4	#			F	0	0	system:logininfor:unlock	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1046	在线查询	109	1	#			F	0	0	monitor:online:query	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1047	批量强退	109	2	#			F	0	0	monitor:online:batchLogout	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1048	单条强退	109	3	#			F	0	0	monitor:online:forceLogout	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1049	任务查询	110	1	#			F	0	0	monitor:job:query	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1050	任务新增	110	2	#			F	0	0	monitor:job:add	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1051	任务修改	110	3	#			F	0	0	monitor:job:edit	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1052	任务删除	110	4	#			F	0	0	monitor:job:remove	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1053	状态修改	110	5	#			F	0	0	monitor:job:changeStatus	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1054	任务导出	110	6	#			F	0	0	monitor:job:export	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1056	生成修改	115	2	#			F	0	0	tool:gen:edit	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1057	生成删除	115	3	#			F	0	0	tool:gen:remove	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1058	导入代码	115	2	#			F	0	0	tool:gen:import	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1059	预览代码	115	4	#			F	0	0	tool:gen:preview	#	admin	2024-12-27 23:15:30.430232		\N			1	0
1060	生成代码	115	5	#			F	0	0	tool:gen:code	#	admin	2024-12-27 23:15:30.430232		\N			1	0
115	代码生成	3	2	gen	tool/gen/index		C	0	0	tool:gen:list	code	admin	2024-12-27 23:15:30.430232	ry	2024-12-28 14:37:12.682926	代码生成菜单		1	0
1055	生成查询	115	1	#			F	0	0	tool:gen:query	#	admin	2024-12-27 23:15:30.430232	ry	2024-12-28 14:37:20.83636			1	0
\.


--
-- Data for Name: sys_notice; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_notice (notice_id, notice_title, notice_type, notice_content, status, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	温馨提醒：2018-07-01 若依新版本发布啦	2	新版本内容	0	admin	2024-12-27 23:29:57.172584		\N	管理员
2	维护通知：2018-07-01 若依系统凌晨维护	1	维护内容	0	admin	2024-12-27 23:29:57.172584		\N	管理员
\.


--
-- Data for Name: sys_oper_log; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_oper_log (oper_id, title, business_type, method, request_method, operator_type, oper_name, dept_name, oper_url, oper_ip, oper_location, oper_param, json_result, status, error_msg, oper_time, cost_time) FROM stdin;
1	角色管理	2	com.ruoyi.system.controller.SysRoleController.edit()	PUT	1	admin	\N	/role	127.0.0.1		{"admin":false,"createTime":"2024-12-27 23:13:24","dataScope":"2","delFlag":"0","deptCheckStrictly":true,"flag":false,"menuCheckStrictly":true,"menuIds":[1,100,1000,1001,1002,1003,1004,1005,1006,101,1007,1008,1009,1010,1011,102,1012,1013,1014,1015,103,1016,1017,1018,1019,104,1020,1021,1022,1023,1024,105,1025,1026,1027,1028,1029,106,1030,1031,1032,1033,1034,107,1035,1036,1037,1038,108,500,1039,1040,1041,501,1042,1043,1044,1045,2,109,1046,1047,1048,110,1049,1050,1051,1052,1053,1054,111,112,113,3,114,115,1055,1056,1058,1057,1059,1060,116,4],"params":{},"remark":"普通角色","roleId":2,"roleKey":"common","roleName":"普通角色","roleSort":2,"status":"0","updateBy":"admin"}	\N	1	\r\n### Error updating database.  Cause: org.postgresql.util.PSQLException: 错误: 字段 "menu_check_strictly" 的类型为 integer, 但表达式的类型为 boolean\n  建议：你需要重写或转换表达式\n  位置：127\r\n### The error may exist in file [D:\\eclipse-workspace\\RuoYi-Cloud\\ruoyi-modules\\ruoyi-system\\target\\classes\\mapper\\system\\SysRoleMapper.xml]\r\n### The error may involve com.ruoyi.system.mapper.SysRoleMapper.updateRole-Inline\r\n### The error occurred while setting parameters\r\n### SQL: update sys_role     SET role_name = ?,     role_key = ?,     role_sort = ?,     data_scope = ?,     menu_check_strictly = ?,     dept_check_strictly = ?,     status = ?,     remark = ?,     update_by = ?,     update_time = now()     where role_id = ?\r\n### Cause: org.postgresql.util.PSQLException: 错误: 字段 "menu_check_strictly" 的类型为 integer, 但表达式的类型为 boolean\n  建议：你需要重写或转换表达式\n  位置：127\n; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: 错误: 字段 "menu_check_strictly" 的类型为 integer, 但表达式的类型为 boolean\n  建议：你需要重写或转换表达式\n  位置：127	2024-12-28 12:46:03.078596	82
2	角色管理	2	com.ruoyi.system.controller.SysRoleController.edit()	PUT	1	admin	\N	/role	127.0.0.1		{"admin":false,"createTime":"2024-12-27 23:13:24","dataScope":"2","delFlag":"0","deptCheckStrictly":true,"flag":false,"menuCheckStrictly":true,"menuIds":[1,100,1000,1001,1002,1003,1004,1005,1006,101,1007,1008,1009,1010,1011,102,1012,1013,1014,1015,103,1016,1017,1018,1019,104,1020,1021,1022,1023,1024,105,1025,1026,1027,1028,1029,106,1030,1031,1032,1033,1034,107,1035,1036,1037,1038,108,500,1039,1040,1041,501,1042,1043,1044,1045,2,109,1046,1047,1048,110,1049,1050,1051,1052,1053,1054,111,112,113,3,114,115,1055,1056,1058,1057,1059,1060,116,4],"params":{},"remark":"普通角色","roleId":2,"roleKey":"common","roleName":"普通角色","roleSort":2,"status":"0","updateBy":"admin"}	\N	1	\r\n### Error updating database.  Cause: org.postgresql.util.PSQLException: 错误: 字段 "dept_check_strictly" 的类型为 integer, 但表达式的类型为 boolean\n  建议：你需要重写或转换表达式\n  位置：157\r\n### The error may exist in file [D:\\eclipse-workspace\\RuoYi-Cloud\\ruoyi-modules\\ruoyi-system\\target\\classes\\mapper\\system\\SysRoleMapper.xml]\r\n### The error may involve com.ruoyi.system.mapper.SysRoleMapper.updateRole-Inline\r\n### The error occurred while setting parameters\r\n### SQL: update sys_role     SET role_name = ?,     role_key = ?,     role_sort = ?,     data_scope = ?,     menu_check_strictly = ?,     dept_check_strictly = ?,     status = ?,     remark = ?,     update_by = ?,     update_time = now()     where role_id = ?\r\n### Cause: org.postgresql.util.PSQLException: 错误: 字段 "dept_check_strictly" 的类型为 integer, 但表达式的类型为 boolean\n  建议：你需要重写或转换表达式\n  位置：157\n; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: 错误: 字段 "dept_check_strictly" 的类型为 integer, 但表达式的类型为 boolean\n  建议：你需要重写或转换表达式\n  位置：157	2024-12-28 12:49:19.746939	14
3	角色管理	2	com.ruoyi.system.controller.SysRoleController.edit()	PUT	1	admin	\N	/role	127.0.0.1		{"admin":false,"createTime":"2024-12-27 23:13:24","dataScope":"2","delFlag":"0","deptCheckStrictly":true,"flag":false,"menuCheckStrictly":true,"menuIds":[1,100,1000,1001,1002,1003,1004,1005,1006,101,1007,1008,1009,1010,1011,102,1012,1013,1014,1015,103,1016,1017,1018,1019,104,1020,1021,1022,1023,1024,105,1025,1026,1027,1028,1029,106,1030,1031,1032,1033,1034,107,1035,1036,1037,1038,108,500,1039,1040,1041,501,1042,1043,1044,1045,2,109,1046,1047,1048,110,1049,1050,1051,1052,1053,1054,111,112,113,3,114,115,1055,1056,1058,1057,1059,1060,116,4],"params":{},"remark":"普通角色","roleId":2,"roleKey":"common","roleName":"普通角色","roleSort":2,"status":"0","updateBy":"admin"}	\N	1	\r\n### Error updating database.  Cause: org.postgresql.util.PSQLException: 错误: 字段 "dept_check_strictly" 的类型为 integer, 但表达式的类型为 boolean\n  建议：你需要重写或转换表达式\n  位置：157\r\n### The error may exist in file [D:\\eclipse-workspace\\RuoYi-Cloud\\ruoyi-modules\\ruoyi-system\\target\\classes\\mapper\\system\\SysRoleMapper.xml]\r\n### The error may involve com.ruoyi.system.mapper.SysRoleMapper.updateRole-Inline\r\n### The error occurred while setting parameters\r\n### SQL: update sys_role     SET role_name = ?,     role_key = ?,     role_sort = ?,     data_scope = ?,     menu_check_strictly = ?,     dept_check_strictly = ?,     status = ?,     remark = ?,     update_by = ?,     update_time = now()     where role_id = ?\r\n### Cause: org.postgresql.util.PSQLException: 错误: 字段 "dept_check_strictly" 的类型为 integer, 但表达式的类型为 boolean\n  建议：你需要重写或转换表达式\n  位置：157\n; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: 错误: 字段 "dept_check_strictly" 的类型为 integer, 但表达式的类型为 boolean\n  建议：你需要重写或转换表达式\n  位置：157	2024-12-28 12:50:22.318235	8
4	角色管理	2	com.ruoyi.system.controller.SysRoleController.edit()	PUT	1	admin	\N	/role	127.0.0.1		{"admin":false,"createTime":"2024-12-27 23:13:24","dataScope":"2","delFlag":"0","deptCheckStrictly":true,"flag":false,"menuCheckStrictly":true,"menuIds":[1,100,1000,1001,1002,1003,1004,1005,1006,101,1007,1008,1009,1010,1011,102,1012,1013,1014,1015,103,1016,1017,1018,1019,104,1020,1021,1022,1023,1024,105,1025,1026,1027,1028,1029,106,1030,1031,1032,1033,1034,107,1035,1036,1037,1038,108,500,1039,1040,1041,501,1042,1043,1044,1045,2,109,1046,1047,1048,110,1049,1050,1051,1052,1053,1054,111,112,113,3,114,115,1055,1056,1058,1057,1059,1060,116,4],"params":{},"remark":"普通角色","roleId":2,"roleKey":"common","roleName":"普通角色","roleSort":2,"status":"0","updateBy":"admin"}	{"msg":"操作成功","code":200}	0	\N	2024-12-28 12:51:09.18629	34
5	用户管理	2	com.ruoyi.system.controller.SysUserController.changeStatus()	PUT	1	admin	\N	/user/changeStatus	127.0.0.1		{"admin":true,"params":{},"status":"1","userId":1}	\N	1	不允许操作超级管理员用户	2024-12-28 12:51:18.934753	43
6	用户管理	2	com.ruoyi.system.controller.SysUserController.edit()	PUT	1	admin	\N	/user	127.0.0.1		{"admin":false,"avatar":"","createBy":"admin","createTime":"2024-12-27 23:10:41","delFlag":"0","dept":{"ancestors":"0,100,101","children":[],"deptId":105,"deptName":"测试部门","leader":"若依","orderNum":3,"params":{},"parentId":101,"status":"0"},"deptId":105,"email":"ry@qq.com","loginDate":"2024-12-27 23:10:41.541","loginIp":"127.0.0.1","nickName":"若依","params":{},"phonenumber":"15666666666","postIds":[2],"remark":"测试员","roleIds":[2],"roles":[{"admin":false,"dataScope":"2","deptCheckStrictly":false,"flag":false,"menuCheckStrictly":false,"params":{},"roleId":2,"roleKey":"common","roleName":"普通角色","roleSort":2,"status":"0"}],"sex":"1","status":"0","updateBy":"admin","userId":2,"userName":"ry"}	{"msg":"操作成功","code":200}	0	\N	2024-12-28 12:52:44.058942	35
7	菜单管理	2	com.ruoyi.system.controller.SysMenuController.edit()	PUT	1	ry	\N	/menu	127.0.0.1		{"children":[],"component":"tool/gen/index","createTime":"2024-12-27 23:15:30","icon":"code","isCache":"0","isFrame":"1","menuId":115,"menuName":"代码生成","menuType":"C","orderNum":2,"params":{},"parentId":3,"path":"gen","perms":"tool:gen:list","query":"","routeName":"","status":"0","updateBy":"ry","visible":"0"}	\N	1	\r\n### Error updating database.  Cause: org.postgresql.util.PSQLException: 错误: 语法错误 在 "`" 或附近的\n  位置：114\r\n### The error may exist in file [D:\\eclipse-workspace\\RuoYi-Cloud\\ruoyi-modules\\ruoyi-system\\target\\classes\\mapper\\system\\SysMenuMapper.xml]\r\n### The error may involve com.ruoyi.system.mapper.SysMenuMapper.updateMenu-Inline\r\n### The error occurred while setting parameters\r\n### SQL: update sys_menu    SET menu_name = ?,    parent_id = ?,    order_num = ?,    path = ?,    component = ?,    `query` = ?,    route_name = ?,    is_frame = ?,    is_cache = ?,    menu_type = ?,    visible = ?,    status = ?,    perms = ?,    icon = ?,        update_by = ?,    update_time = now()    where menu_id = ?\r\n### Cause: org.postgresql.util.PSQLException: 错误: 语法错误 在 "`" 或附近的\n  位置：114\n; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: 错误: 语法错误 在 "`" 或附近的\n  位置：114	2024-12-28 12:59:05.0943	94
8	菜单管理	2	com.ruoyi.system.controller.SysMenuController.edit()	PUT	1	ry	\N	/menu	127.0.0.1		{"children":[],"component":"tool/gen/index","createTime":"2024-12-27 23:15:30","icon":"code","isCache":"0","isFrame":"1","menuId":115,"menuName":"代码生成","menuType":"C","orderNum":2,"params":{},"parentId":3,"path":"gen","perms":"tool:gen:list","query":"","routeName":"","status":"0","updateBy":"ry","visible":"0"}	\N	1	\r\n### Error updating database.  Cause: org.postgresql.util.PSQLException: 错误: 字段 "is_frame" 的类型为 integer, 但表达式的类型为 character varying\n  建议：你需要重写或转换表达式\n  位置：160\r\n### The error may exist in file [D:\\eclipse-workspace\\RuoYi-Cloud\\ruoyi-modules\\ruoyi-system\\target\\classes\\mapper\\system\\SysMenuMapper.xml]\r\n### The error may involve com.ruoyi.system.mapper.SysMenuMapper.updateMenu-Inline\r\n### The error occurred while setting parameters\r\n### SQL: update sys_menu    SET menu_name = ?,    parent_id = ?,    order_num = ?,    path = ?,    component = ?,    query = ?,    route_name = ?,    is_frame = ?,    is_cache = ?,    menu_type = ?,    visible = ?,    status = ?,    perms = ?,    icon = ?,        update_by = ?,    update_time = now()    where menu_id = ?\r\n### Cause: org.postgresql.util.PSQLException: 错误: 字段 "is_frame" 的类型为 integer, 但表达式的类型为 character varying\n  建议：你需要重写或转换表达式\n  位置：160\n; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: 错误: 字段 "is_frame" 的类型为 integer, 但表达式的类型为 character varying\n  建议：你需要重写或转换表达式\n  位置：160	2024-12-28 13:00:34.678289	72
9	菜单管理	2	com.ruoyi.system.controller.SysMenuController.edit()	PUT	1	ry	\N	/menu	127.0.0.1		{"children":[],"component":"tool/gen/index","createTime":"2024-12-27 23:15:30","icon":"code","isCache":"0","isFrame":"1","menuId":115,"menuName":"代码生成","menuType":"C","orderNum":2,"params":{},"parentId":3,"path":"gen","perms":"tool:gen:list","query":"","routeName":"","status":"0","updateBy":"ry","visible":"0"}	\N	1	\r\n### Error updating database.  Cause: org.postgresql.util.PSQLException: 错误: 字段 "is_frame" 的类型为 integer, 但表达式的类型为 character varying\n  建议：你需要重写或转换表达式\n  位置：160\r\n### The error may exist in file [D:\\eclipse-workspace\\RuoYi-Cloud\\ruoyi-modules\\ruoyi-system\\target\\classes\\mapper\\system\\SysMenuMapper.xml]\r\n### The error may involve com.ruoyi.system.mapper.SysMenuMapper.updateMenu-Inline\r\n### The error occurred while setting parameters\r\n### SQL: update sys_menu    SET menu_name = ?,    parent_id = ?,    order_num = ?,    path = ?,    component = ?,    query = ?,    route_name = ?,    is_frame = ?,    is_cache = ?,    menu_type = ?,    visible = ?,    status = ?,    perms = ?,    icon = ?,        update_by = ?,    update_time = now()    where menu_id = ?\r\n### Cause: org.postgresql.util.PSQLException: 错误: 字段 "is_frame" 的类型为 integer, 但表达式的类型为 character varying\n  建议：你需要重写或转换表达式\n  位置：160\n; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: 错误: 字段 "is_frame" 的类型为 integer, 但表达式的类型为 character varying\n  建议：你需要重写或转换表达式\n  位置：160	2024-12-28 13:00:44.04424	16
10	菜单管理	2	com.ruoyi.system.controller.SysMenuController.edit()	PUT	1	ry	\N	/menu	127.0.0.1		{"children":[],"component":"tool/gen/index","createTime":"2024-12-27 23:15:30","icon":"code","isCache":"0","isFrame":"1","menuId":115,"menuName":"代码生成","menuType":"C","orderNum":2,"params":{},"parentId":3,"path":"gen","perms":"tool:gen:list","query":"","routeName":"","status":"0","updateBy":"ry","visible":"0"}	\N	1	\r\n### Error updating database.  Cause: org.postgresql.util.PSQLException: 错误: 字段 "is_cache" 的类型为 integer, 但表达式的类型为 character varying\n  建议：你需要重写或转换表达式\n  位置：178\r\n### The error may exist in file [D:\\eclipse-workspace\\RuoYi-Cloud\\ruoyi-modules\\ruoyi-system\\target\\classes\\mapper\\system\\SysMenuMapper.xml]\r\n### The error may involve com.ruoyi.system.mapper.SysMenuMapper.updateMenu-Inline\r\n### The error occurred while setting parameters\r\n### SQL: update sys_menu    SET menu_name = ?,    parent_id = ?,    order_num = ?,    path = ?,    component = ?,    query = ?,    route_name = ?,    is_frame = ?,    is_cache = ?,    menu_type = ?,    visible = ?,    status = ?,    perms = ?,    icon = ?,        update_by = ?,    update_time = now()    where menu_id = ?\r\n### Cause: org.postgresql.util.PSQLException: 错误: 字段 "is_cache" 的类型为 integer, 但表达式的类型为 character varying\n  建议：你需要重写或转换表达式\n  位置：178\n; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: 错误: 字段 "is_cache" 的类型为 integer, 但表达式的类型为 character varying\n  建议：你需要重写或转换表达式\n  位置：178	2024-12-28 13:02:48.624132	9
11	菜单管理	2	com.ruoyi.system.controller.SysMenuController.edit()	PUT	1	ry	\N	/menu	127.0.0.1		{"children":[],"component":"tool/gen/index","createTime":"2024-12-27 23:15:30","icon":"code","isCache":"0","isFrame":"1","menuId":115,"menuName":"代码生成","menuType":"C","orderNum":2,"params":{},"parentId":3,"path":"gen","perms":"tool:gen:list","query":"","routeName":"","status":"0","updateBy":"ry","visible":"0"}	{"msg":"操作成功","code":200}	0	\N	2024-12-28 13:03:41.824879	15
12	角色管理	2	com.ruoyi.system.controller.SysRoleController.edit()	PUT	1	ry	\N	/role	127.0.0.1		{"admin":false,"createTime":"2024-12-27 23:13:24","dataScope":"2","delFlag":"0","deptCheckStrictly":true,"flag":false,"menuCheckStrictly":true,"menuIds":[1,100,1000,1001,1002,1003,1004,1005,1006,101,1007,1008,1009,1010,1011,102,1012,1013,1014,1015,103,1016,1017,1018,1019,104,1020,1021,1022,1023,1024,105,1025,1026,1027,1028,1029,106,1030,1031,1032,1033,1034,107,1035,1036,1037,1038,108,500,1039,1040,1041,501,1042,1043,1044,1045,2,109,1046,1047,1048,110,1049,1050,1051,1052,1053,1054,111,112,113,3,114,115,1055,1056,1058,1057,1059,1060,116,4],"params":{},"remark":"普通角色","roleId":2,"roleKey":"common","roleName":"普通角色","roleSort":2,"status":"0","updateBy":"ry"}	{"msg":"操作成功","code":200}	0	\N	2024-12-28 14:36:29.907982	120
13	用户管理	2	com.ruoyi.system.controller.SysUserController.edit()	PUT	1	ry	\N	/user	127.0.0.1		{"admin":false,"avatar":"","createBy":"admin","createTime":"2024-12-27 23:10:41","delFlag":"0","dept":{"ancestors":"0,100,101","children":[],"deptId":105,"deptName":"测试部门","leader":"若依","orderNum":3,"params":{},"parentId":101,"status":"0"},"deptId":105,"email":"ry@qq.com","loginDate":"2024-12-28 12:53:00.755","loginIp":"127.0.0.1","nickName":"若依","params":{},"phonenumber":"15666666666","postIds":[2],"remark":"测试员","roleIds":[2],"roles":[{"admin":false,"dataScope":"2","deptCheckStrictly":false,"flag":false,"menuCheckStrictly":false,"params":{},"roleId":2,"roleKey":"common","roleName":"普通角色","roleSort":2,"status":"0"}],"sex":"1","status":"0","updateBy":"ry","userId":2,"userName":"ry"}	{"msg":"操作成功","code":200}	0	\N	2024-12-28 14:36:55.385779	47
14	菜单管理	2	com.ruoyi.system.controller.SysMenuController.edit()	PUT	1	ry	\N	/menu	127.0.0.1		{"children":[],"createTime":"2024-12-27 23:15:30","icon":"monitor","isCache":"0","isFrame":"1","menuId":2,"menuName":"系统监控","menuType":"M","orderNum":2,"params":{},"parentId":0,"path":"monitor","perms":"","query":"","routeName":"","status":"0","updateBy":"ry","visible":"0"}	{"msg":"操作成功","code":200}	0	\N	2024-12-28 14:37:04.637196	7
15	菜单管理	2	com.ruoyi.system.controller.SysMenuController.edit()	PUT	1	ry	\N	/menu	127.0.0.1		{"children":[],"createTime":"2024-12-27 23:15:30","icon":"tool","isCache":"0","isFrame":"1","menuId":3,"menuName":"系统工具","menuType":"M","orderNum":3,"params":{},"parentId":0,"path":"tool","perms":"","query":"","routeName":"","status":"0","updateBy":"ry","visible":"0"}	{"msg":"操作成功","code":200}	0	\N	2024-12-28 14:37:07.775979	7
16	菜单管理	2	com.ruoyi.system.controller.SysMenuController.edit()	PUT	1	ry	\N	/menu	127.0.0.1		{"children":[],"component":"tool/gen/index","createTime":"2024-12-27 23:15:30","icon":"code","isCache":"0","isFrame":"1","menuId":115,"menuName":"代码生成","menuType":"C","orderNum":2,"params":{},"parentId":3,"path":"gen","perms":"tool:gen:list","query":"","routeName":"","status":"0","updateBy":"ry","visible":"0"}	{"msg":"操作成功","code":200}	0	\N	2024-12-28 14:37:12.705958	5
17	菜单管理	2	com.ruoyi.system.controller.SysMenuController.edit()	PUT	1	ry	\N	/menu	127.0.0.1		{"children":[],"component":"","createTime":"2024-12-27 23:15:30","icon":"#","isCache":"0","isFrame":"1","menuId":1055,"menuName":"生成查询","menuType":"F","orderNum":1,"params":{},"parentId":115,"path":"#","perms":"tool:gen:query","query":"","routeName":"","status":"0","updateBy":"ry","visible":"0"}	{"msg":"操作成功","code":200}	0	\N	2024-12-28 14:37:20.852388	8
18	代码生成	6	com.ruoyi.gen.controller.GenController.importTableSave()	POST	1	admin	\N	/gen/importTable	127.0.0.1		{"tables":"test"}	{"msg":"操作成功","code":200}	0	\N	2024-12-28 15:09:16.591172	99
19	代码生成	3	com.ruoyi.gen.controller.GenController.remove()	DELETE	1	admin	\N	/gen/1	127.0.0.1		[1]	{"msg":"操作成功","code":200}	0	\N	2024-12-28 15:10:07.91041	17
20	代码生成	6	com.ruoyi.gen.controller.GenController.importTableSave()	POST	1	admin	\N	/gen/importTable	127.0.0.1		{"tables":"test"}	{"msg":"操作成功","code":200}	0	\N	2024-12-28 15:10:12.544292	37
21	代码生成	3	com.ruoyi.gen.controller.GenController.remove()	DELETE	1	admin	\N	/gen/2	127.0.0.1		[2]	{"msg":"操作成功","code":200}	0	\N	2024-12-28 15:10:54.231423	6
22	代码生成	6	com.ruoyi.gen.controller.GenController.importTableSave()	POST	1	admin	\N	/gen/importTable	127.0.0.1		{"tables":"test"}	{"msg":"操作成功","code":200}	0	\N	2024-12-28 15:11:01.432454	31
23	代码生成	8	com.ruoyi.gen.controller.GenController.batchGenCode()	GET	1	admin	\N	/gen/batchGenCode	127.0.0.1		{"tables":"test"}	\N	0	\N	2024-12-28 15:14:29.517864	894
24	代码生成	3	com.ruoyi.gen.controller.GenController.remove()	DELETE	1	admin	\N	/gen/3	127.0.0.1		[3]	{"msg":"操作成功","code":200}	0	\N	2024-12-28 15:16:30.986541	9
25	代码生成	6	com.ruoyi.gen.controller.GenController.importTableSave()	POST	1	admin	\N	/gen/importTable	127.0.0.1		{"tables":"test"}	{"msg":"操作成功","code":200}	0	\N	2024-12-28 15:16:34.924301	69
26	代码生成	3	com.ruoyi.gen.controller.GenController.remove()	DELETE	1	admin	\N	/gen/4	127.0.0.1		[4]	{"msg":"操作成功","code":200}	0	\N	2024-12-28 15:18:33.582137	22
\.


--
-- Data for Name: sys_post; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_post (post_id, post_code, post_name, post_sort, status, create_by, create_time, update_by, update_time, remark) FROM stdin;
1	ceo	董事长	1	0	admin	2024-12-27 23:11:56.823985		\N	
2	se	项目经理	2	0	admin	2024-12-27 23:11:56.823985		\N	
3	hr	人力资源	3	0	admin	2024-12-27 23:11:56.823985		\N	
4	user	普通员工	4	0	admin	2024-12-27 23:11:56.823985		\N	
\.


--
-- Data for Name: sys_role; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_role (role_id, role_name, role_key, role_sort, data_scope, status, del_flag, create_by, create_time, update_by, update_time, remark, menu_check_strictly, dept_check_strictly) FROM stdin;
1	超级管理员	admin	1	1	0	0	admin	2024-12-27 23:13:24.913417		\N	超级管理员	t	t
2	普通角色	common	2	2	0	0	admin	2024-12-27 23:13:24.913417	ry	2024-12-28 14:36:29.80753	普通角色	t	t
\.


--
-- Data for Name: sys_role_dept; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_role_dept (role_id, dept_id) FROM stdin;
2	100
2	101
2	105
\.


--
-- Data for Name: sys_role_menu; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_role_menu (role_id, menu_id) FROM stdin;
2	1
2	100
2	1000
2	1001
2	1002
2	1003
2	1004
2	1005
2	1006
2	101
2	1007
2	1008
2	1009
2	1010
2	1011
2	102
2	1012
2	1013
2	1014
2	1015
2	103
2	1016
2	1017
2	1018
2	1019
2	104
2	1020
2	1021
2	1022
2	1023
2	1024
2	105
2	1025
2	1026
2	1027
2	1028
2	1029
2	106
2	1030
2	1031
2	1032
2	1033
2	1034
2	107
2	1035
2	1036
2	1037
2	1038
2	108
2	500
2	1039
2	1040
2	1041
2	501
2	1042
2	1043
2	1044
2	1045
2	2
2	109
2	1046
2	1047
2	1048
2	110
2	1049
2	1050
2	1051
2	1052
2	1053
2	1054
2	111
2	112
2	113
2	3
2	114
2	115
2	1055
2	1056
2	1058
2	1057
2	1059
2	1060
2	116
2	4
\.


--
-- Data for Name: sys_user; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark) FROM stdin;
2	105	ry	若依	00	ry@qq.com	15666666666	1		$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2	0	0	127.0.0.1	2024-12-28 12:53:00.755	admin	2024-12-27 23:10:41.54193	ry	2024-12-28 14:36:55.328915	测试员
1	103	admin	若依	00	ry@163.com	15888888888	1		$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2	0	0	127.0.0.1	2024-12-28 15:01:15.956	admin	2024-12-27 23:10:41.54193		2024-12-28 15:01:15.995045	管理员
\.


--
-- Data for Name: sys_user_post; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_user_post (user_id, post_id) FROM stdin;
1	1
2	2
\.


--
-- Data for Name: sys_user_role; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_user_role (user_id, role_id) FROM stdin;
1	1
2	2
\.


--
-- Name: gen_table_column_column_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.gen_table_column_column_id_seq', 15, true);


--
-- Name: gen_table_table_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.gen_table_table_id_seq', 4, true);


--
-- Name: sys_config_config_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_config_config_id_seq', 1, false);


--
-- Name: sys_dept_dept_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_dept_dept_id_seq', 1, false);


--
-- Name: sys_dict_data_dict_code_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_dict_data_dict_code_seq', 1, false);


--
-- Name: sys_dict_type_dict_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_dict_type_dict_id_seq', 1, false);


--
-- Name: sys_job_job_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_job_job_id_seq', 1, false);


--
-- Name: sys_job_log_job_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_job_log_job_log_id_seq', 1, false);


--
-- Name: sys_logininfor_info_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_logininfor_info_id_seq', 11, true);


--
-- Name: sys_menu_menu_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_menu_menu_id_seq', 1, false);


--
-- Name: sys_notice_notice_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_notice_notice_id_seq', 1, false);


--
-- Name: sys_oper_log_oper_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_oper_log_oper_id_seq', 26, true);


--
-- Name: sys_post_post_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_post_post_id_seq', 1, false);


--
-- Name: sys_role_role_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_role_role_id_seq', 1, false);


--
-- Name: sys_user_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_user_user_id_seq', 1, false);


--
-- Name: gen_table_column gen_table_column_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.gen_table_column
    ADD CONSTRAINT gen_table_column_pkey PRIMARY KEY (column_id);


--
-- Name: gen_table gen_table_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.gen_table
    ADD CONSTRAINT gen_table_pkey PRIMARY KEY (table_id);


--
-- Name: qrtz_blob_triggers qrtz_blob_triggers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.qrtz_blob_triggers
    ADD CONSTRAINT qrtz_blob_triggers_pkey PRIMARY KEY (sched_name, trigger_name, trigger_group);


--
-- Name: qrtz_calendars qrtz_calendars_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.qrtz_calendars
    ADD CONSTRAINT qrtz_calendars_pkey PRIMARY KEY (sched_name, calendar_name);


--
-- Name: qrtz_cron_triggers qrtz_cron_triggers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.qrtz_cron_triggers
    ADD CONSTRAINT qrtz_cron_triggers_pkey PRIMARY KEY (sched_name, trigger_name, trigger_group);


--
-- Name: qrtz_fired_triggers qrtz_fired_triggers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.qrtz_fired_triggers
    ADD CONSTRAINT qrtz_fired_triggers_pkey PRIMARY KEY (sched_name, entry_id);


--
-- Name: qrtz_job_details qrtz_job_details_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.qrtz_job_details
    ADD CONSTRAINT qrtz_job_details_pkey PRIMARY KEY (sched_name, job_name, job_group);


--
-- Name: qrtz_locks qrtz_locks_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.qrtz_locks
    ADD CONSTRAINT qrtz_locks_pkey PRIMARY KEY (sched_name, lock_name);


--
-- Name: qrtz_paused_trigger_grps qrtz_paused_trigger_grps_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.qrtz_paused_trigger_grps
    ADD CONSTRAINT qrtz_paused_trigger_grps_pkey PRIMARY KEY (sched_name, trigger_group);


--
-- Name: qrtz_scheduler_state qrtz_scheduler_state_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.qrtz_scheduler_state
    ADD CONSTRAINT qrtz_scheduler_state_pkey PRIMARY KEY (sched_name, instance_name);


--
-- Name: qrtz_simple_triggers qrtz_simple_triggers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.qrtz_simple_triggers
    ADD CONSTRAINT qrtz_simple_triggers_pkey PRIMARY KEY (sched_name, trigger_name, trigger_group);


--
-- Name: qrtz_simprop_triggers qrtz_simprop_triggers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.qrtz_simprop_triggers
    ADD CONSTRAINT qrtz_simprop_triggers_pkey PRIMARY KEY (sched_name, trigger_name, trigger_group);


--
-- Name: qrtz_triggers qrtz_triggers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.qrtz_triggers
    ADD CONSTRAINT qrtz_triggers_pkey PRIMARY KEY (sched_name, trigger_name, trigger_group);


--
-- Name: sys_config sys_config_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_config
    ADD CONSTRAINT sys_config_pkey PRIMARY KEY (config_id);


--
-- Name: sys_dept sys_dept_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_dept
    ADD CONSTRAINT sys_dept_pkey PRIMARY KEY (dept_id);


--
-- Name: sys_dict_data sys_dict_data_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_dict_data
    ADD CONSTRAINT sys_dict_data_pkey PRIMARY KEY (dict_code);


--
-- Name: sys_dict_type sys_dict_type_dict_type_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_dict_type
    ADD CONSTRAINT sys_dict_type_dict_type_key UNIQUE (dict_type);


--
-- Name: sys_dict_type sys_dict_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_dict_type
    ADD CONSTRAINT sys_dict_type_pkey PRIMARY KEY (dict_id);


--
-- Name: sys_job_log sys_job_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_job_log
    ADD CONSTRAINT sys_job_log_pkey PRIMARY KEY (job_log_id);


--
-- Name: sys_job sys_job_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_job
    ADD CONSTRAINT sys_job_pkey PRIMARY KEY (job_id, job_name, job_group);


--
-- Name: sys_logininfor sys_logininfor_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_logininfor
    ADD CONSTRAINT sys_logininfor_pkey PRIMARY KEY (info_id);


--
-- Name: sys_menu sys_menu_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_menu
    ADD CONSTRAINT sys_menu_pkey PRIMARY KEY (menu_id);


--
-- Name: sys_notice sys_notice_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_notice
    ADD CONSTRAINT sys_notice_pkey PRIMARY KEY (notice_id);


--
-- Name: sys_oper_log sys_oper_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_oper_log
    ADD CONSTRAINT sys_oper_log_pkey PRIMARY KEY (oper_id);


--
-- Name: sys_post sys_post_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_post
    ADD CONSTRAINT sys_post_pkey PRIMARY KEY (post_id);


--
-- Name: sys_role_dept sys_role_dept_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_role_dept
    ADD CONSTRAINT sys_role_dept_pkey PRIMARY KEY (role_id, dept_id);


--
-- Name: sys_role_menu sys_role_menu_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_role_menu
    ADD CONSTRAINT sys_role_menu_pkey PRIMARY KEY (role_id, menu_id);


--
-- Name: sys_role sys_role_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_role
    ADD CONSTRAINT sys_role_pkey PRIMARY KEY (role_id);


--
-- Name: sys_user sys_user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_user
    ADD CONSTRAINT sys_user_pkey PRIMARY KEY (user_id);


--
-- Name: sys_user_post sys_user_post_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_user_post
    ADD CONSTRAINT sys_user_post_pkey PRIMARY KEY (user_id, post_id);


--
-- Name: sys_user_role sys_user_role_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_user_role
    ADD CONSTRAINT sys_user_role_pkey PRIMARY KEY (user_id, role_id);


--
-- Name: qrtz_blob_triggers qrtz_blob_triggers_sched_name_trigger_name_trigger_group_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.qrtz_blob_triggers
    ADD CONSTRAINT qrtz_blob_triggers_sched_name_trigger_name_trigger_group_fkey FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES public.qrtz_triggers(sched_name, trigger_name, trigger_group);


--
-- Name: qrtz_cron_triggers qrtz_cron_triggers_sched_name_trigger_name_trigger_group_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.qrtz_cron_triggers
    ADD CONSTRAINT qrtz_cron_triggers_sched_name_trigger_name_trigger_group_fkey FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES public.qrtz_triggers(sched_name, trigger_name, trigger_group);


--
-- Name: qrtz_simple_triggers qrtz_simple_triggers_sched_name_trigger_name_trigger_group_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.qrtz_simple_triggers
    ADD CONSTRAINT qrtz_simple_triggers_sched_name_trigger_name_trigger_group_fkey FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES public.qrtz_triggers(sched_name, trigger_name, trigger_group);


--
-- Name: qrtz_simprop_triggers qrtz_simprop_triggers_sched_name_trigger_name_trigger_grou_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.qrtz_simprop_triggers
    ADD CONSTRAINT qrtz_simprop_triggers_sched_name_trigger_name_trigger_grou_fkey FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES public.qrtz_triggers(sched_name, trigger_name, trigger_group);


--
-- Name: qrtz_triggers qrtz_triggers_sched_name_job_name_job_group_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.qrtz_triggers
    ADD CONSTRAINT qrtz_triggers_sched_name_job_name_job_group_fkey FOREIGN KEY (sched_name, job_name, job_group) REFERENCES public.qrtz_job_details(sched_name, job_name, job_group);


--
-- PostgreSQL database dump complete
--

